
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[ServiceInfoUpdate]
    @Id UNIQUEIDENTIFIER ,
    @UserInfoId UNIQUEIDENTIFIER ,
    @ServiceTypeId UNIQUEIDENTIFIER ,
    @Name VARBINARY(MAX) ,
    @Url VARBINARY(MAX) ,
    @IconImage IMAGE
AS 
    BEGIN
        UPDATE  ServiceInfo
        SET     UserInfoId = @UserInfoId ,
                ServiceTypeId = @ServiceTypeId ,
                Name = @Name,
                Url = @Url,
                IconImage = @IconImage
        WHERE   Id = @Id

    END
GO
